/*
 * 版权所有 (C) 2015 知启蒙(ZHIQIM) 保留所有权利。[遇见知启蒙，邂逅框架梦]
 * 
 * https://zhiqim.org/project/zhiqim_framework/zhiqim_orm.htm
 *
 * Zhiqim Orm is licensed under Mulan PSL v2.
 * You can use this software according to the terms and conditions of the Mulan PSL v2.
 * You may obtain a copy of Mulan PSL v2 at:
 *          http://license.coscl.org.cn/MulanPSL2
 * THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
 * EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
 * MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
 * See the Mulan PSL v2 for more details.
 */
package org.zhiqim.orm.test.mysql;

import java.sql.Connection;
import java.sql.ParameterMetaData;
import java.sql.PreparedStatement;

import org.zhiqim.kernel.Global;
import org.zhiqim.kernel.util.Closes;
import org.zhiqim.orm.ORMServer;
import org.zhiqim.orm.test.ORMBoot;


public class Statement
{
    public static void main(String[] args) throws Exception
    {
        ORMBoot.initMySQLServer();
        
        String sql = "select * from USER where USER_ID=? and USER_STATUS = ?";
        Connection conn = Global.getService(ORMServer.class).getConnection();
        PreparedStatement pstmt = conn.prepareStatement(sql);
        ParameterMetaData meta = pstmt.getParameterMetaData();
        
        int count = meta.getParameterCount();
        System.out.println(count);
        
        for (int i=0;i<count;i++)
        {
            System.out.println(meta.getParameterClassName(i));
        }
        
        Closes.closeIgnoreException(conn);
    }
}
